Cannot add a record to the middle of a list using data form due to design.
Cause:
New records entered using the data form are always added to the bottom of a list. This is by the design of Microsoft Excel 7.0.
Solution:
Add a record to the middle of a list directly on the worksheet.
1) Select the row above which the new row should be placed on the worksheet.
2) Select the 'Insert' menu and select 'Rows'. (A new row is added above the selected row.)
3) Type the record in the added row.
